﻿CREATE proc thuan_qtdanhmucchuongtrinhloadbyid    
@ID as int    
as      
select a.MaChuongTrinh,a.TenChuongTrinh,a.DienGiai,a.NhomCT ,b.DienGiai as TenNhom  ,a.Hinh
from DanhMuc_ChuongTrinh  a,DanhMuc_NhomChuongTrinh b  
Where a.NhomCT=b.NhomCT and a.MaChuongTrinh=@ID